/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table wireless_entry_analysis \
--export-dir /user/spark/warehouse/09_shop_db/zb1 \
--update-mode allowinsert \
--update-key 'dt,entry_point,unique_visitor_count' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table page_type_stats_result \
--export-dir /user/spark/warehouse/09_shop_db/zb2_page_type_stats_result \
--update-mode allowinsert \
--update-key 'page_type,unique_visitor_count,visitor_ratio' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table page_detail_stats_result \
--export-dir /user/spark/warehouse/09_shop_db/zb2_page_detail_stats_result \
--update-mode allowinsert \
--update-key 'page_type,page_view_count,unique_visitor_count' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table source_stats_result \
--export-dir /user/spark/warehouse/09_shop_db/zb3_source_stats_result \
--update-mode allowinsert \
--update-key 'page_type,unique_visitor_count,unique_visitor_zb' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table destination_stats_result \
--export-dir /user/spark/warehouse/09_shop_db/zb3_destination_stats_result \
--update-mode allowinsert \
--update-key 'page_type,unique_visitor_count,unique_visitor_bl' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table pc_source_analysis_result \
--export-dir /user/spark/warehouse/09_shop_db/pc_source_analysis_result \
--update-mode allowinsert \
--update-key 'page_type,unique_visitor_count,unique_visitor_zb' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table pc_shop_other_pages_top20 \
--export-dir /user/spark/warehouse/09_shop_db/pc_shop_other_pages_top20 \
--update-mode allowinsert \
--update-key 'page_url,unique_visitor_count,unique_visitor_sum' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1


/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table page_visit_ranking_result \
--export-dir /user/spark/warehouse/09_shop_db/page_visit_ranking_result \
--update-mode allowinsert \
--update-key 'pm,fwym,lll' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table pc_source_stats_result \
--export-dir /user/spark/warehouse/09_shop_db/pc_source_stats_result \
--update-mode allowinsert \
--update-key 'page_type,unique_visitor_count,unique_visitor_zb' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/09_shop_db?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table wireless_entry_analysis_result \
--export-dir /user/spark/warehouse/09_shop_db/wireless_entry_analysis_result \
--update-mode allowinsert \
--update-key 'dt,entry_point,visitor_num' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1